Welcome To Snipplr
Everyone's Recent SQL Snippets Tagged sql
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
Per cambiare il tipo di dato in una colonna devo fare un giretto...
0
540
posted 12 years ago by tuffo19
You can use TSQL to Count Number Of Stored Procedures, Views, Tables or Functions in a Database by using the Database INFORMATION_SCHEMA view
0
4414
posted 12 years ago by Mithun
This trigger returns a resultset that includes last inserted record's guid info (uniqueidentifier)
If your column is uniqueidentifier and its default value is newid() , you can't get last record id (guid) with @@identity .
So, I write a trigger...
1
451
posted 13 years ago by emregulcan
You can see details on http://msdn.microsoft.com/en-us/library/ms178592.aspx , but I try to explain how you throw error with "uniqueidentifier" type parameters.
I convert uniqueidentifier to string (nvarchar(50)) and set a variable.
"%s" is equal...
0
1293
posted 13 years ago by emregulcan
My Add Column Varchar.sql
This template adds a new varchar column to the table.
0
550
posted 13 years ago by edwinet
Field1 + Field2 + Field3 should create 1 entry for each unique row in the DB. In an employee table, this would be FirstName + LastName + EmployeeNumber
1
524
posted 13 years ago by ezerick
Search SQL Server field names and stored procedure text, based on a keyword.
1
832
posted 13 years ago by axs221
Today I need Trim() function in sql, but in Sql 2005 there is no function. Because of that I wrote this user (scalar) fuction.
It's very basic;
-First; it's Right Trim (RTrim()) string
- And then Left Trim (LTrim())
0
429
posted 13 years ago by emregulcan
Used the first sql statement to find your menu item. (Replace menu-% with the name of your menu eg. "primary-links" .
Then using the menu item id fix the items you want to regain the good old delete button on the menu item.
0
848
posted 13 years ago by Onfire60