|
|
-
Kirti M.Darji Liked 6 Months ago through Just Learned
If you use "select * into" to create a new table from an existing table having a primary key, then the new table will not have a primary key by default....
|
-
Kirti M.Darji Learned 6 Months ago through Just Learned
If you use "select * into" to create a new table from an existing table having a primary key, then the new table will not have a primary key by default....
|
-
Kirti M.Darji Liked 6 Months ago through Blogs
In this post, there is a workaround for referring tables dynamically in SSIS source task....
|
-
Kirti M.Darji Liked 6 Months ago through Tutorials
This tutorial will help you learning SQL Server Management Studio (SSMS)...
|
|
|
|
|
-
Kirti M.Darji Liked 6 Months ago through Just Learned
Today my colleague came up with a problem that he were not able to restore database having error like follows.
Restore failed for Server '<servername>'. (Microsoft.SqlServer.Smo) System.Data.SqlClient.SqlError: The file "D:\Db.mdf" is compressed bu...
|
-
Kirti M.Darji Learned 6 Months ago through Just Learned
Today my colleague came up with a problem that he were not able to restore database having error like follows.
Restore failed for Server '<servername>'. (Microsoft.SqlServer.Smo) System.Data.SqlClient.SqlError: The file "D:\Db.mdf" is compressed bu...
|
-
Kirti M.Darji liked 6 Months ago through Scripts
This script is use for filter records in dataset using LINQ ...
|
-
Kirti M.Darji Liked 6 Months ago through Blogs
If you wish to copy the column headers from the results tab of the SQL Server Management Studio (SSMS) alongwith the results to another program like Excel, use the built-in functionalities of the SSMS demonstrated in this post....
|